ALTER VIEW [dbo].[View_Demo_Student]
AS
SELECT
         ds.StudentGUID,
         ds.StudentName,
         ds.StudentAge,
         ds.StudentBirthday,
         ds.StudentHeight,
         ds.StudentIsVip,
         ds.StudentLevel,
         ds.ClassGUID,
         ds.StudentDesc,
         ds.StudentFavor,
         ds.TenantId,
         ds.IsDeleted,
         ds.CreateTime,
         ds.CreateGUID,
         ds.CreatedName,
         ds.ModifiedTime,
         ds.ModifiedGUID,
         ds.ModifiedName,
         ds.ApproveState,
         ds.ApproveGUID,
         ds.ApproveTime,
         ds.BuUnitGUID,
		 dc.ClassName
FROM dbo.Demo_Student ds
LEFT JOIN dbo.Demo_Class dc ON dc.ClassGUID = ds.ClassGUID